<?php
	$dbh = new PDO('sqlite:ball_pos');
	
	//get amount of data
	$data = $dbh->prepare("select *from Ball limit 0, 20");
	$data->execute();
	$result = $data->fetchAll();
	
	$array = Array();
	$x_array = Array();
	$x_array["name"] = "X position";
	$y_array = Array();
	$y_array["name"] = "Y position";
	
	$tempX = Array();
	$tempY = Array();
	
	foreach($result as $key=>$value)
	{
		$tempX =array_merge($tempX, Array($value["x"]));
		$tempY = array_merge($tempY, Array($value["y"]));
	}
	
	$x_array["data"] = $tempX;
	$y_array["data"] = $tempY;
	
	array_push($array, $x_array);
	array_push($array, $y_array);
	echo json_encode($array);
	
	/*echo "[
		  {
			"name":"Tokyo",
			"data":[7,6.9,9.5,14.5,18.2,21.5,25.2,26.5,23.3,18.3,13.9,9.6]
		  },
		  {
			"name":"New York",
			"data":[-0.2,0.8,5.7,11.3,17,22,24.8,24.1,20.1,14.1,8.6,2.5]
		  },
		  {
			"name":"Berlin",
			"data":[-0.9,0.6,3.5,8.4,13.5,17,18.6,17.9,14.3,9,3.9,1]
		  },
		  {
			"name":"London",
			"data":[3.9,4.2,5.7,8.5,11.9,15.2,17,16.6,14.2,10.3,6.6,4.8]
		  }
		]";*/
?> 